How to extract records of XML using c# linq?

I have the following XML excerpt. I have no problem extracting the first step of XML but I can't figure out how to get to the second layer and extract each layer. Specifically, the user info in XML below.

Any help will be appreciated.

<?xmlversion="1.0"encoding="UTF-8"?>
  <S:Envelopexmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
    <S:Body>
    <ns2:getStatusReportResponsexmlns:ns2="http://xxxxxxxxx.com/">
      <return>
        <statusReport>
        <record>
          <assessorDate/>
          <assessorOffice/>
          <availableDate/>
          <awardDate>01/01/2014</awardDate>
          <awardValue>1000000</awardValue>
              <businessSector>SYSTEMS</businessSector>
          <user>
            <accessGrantedDate/>
            <emailAddress>john.usda@noemail.mil</emailAddress>
            <name>JOHN USDA</name>
            <phoneNumber>XXX-XXX-XXXX</phoneNumber>
            <role>Focal Point</role>
          </user>
          <user>
            <accessGrantedDate/>
            <emailAddress>john.usda@noemail.mil</emailAddress>
            <name>JOHN USDA</name>
            <phoneNumber>XXX-XXX-XXXX</phoneNumber>
            <role>Focal Point</role>
          </user>
        </record>
       </statusReport>
      </return>
    </ns2:getStatusReportResponse>
    </S:Body>
  </S:Envelope>

I've tried this but it only get's me a list of the first user record and not all of them.

var records = from x in xml.Descendants("record")
selectnew
{
      awardDate = (string)x.Descendants("awardDate").FirstOrDefault().Value,
      userList = (List<string>)x.Descendants("user").Elements().Select(a => a.Value).ToList()
};

c# linq

Updated on 06-Nov-2014

publicclassUser
{
    publicDateTime? AccessGrantedDate { get; set; }
    publicstring EMailAddress { get; set; }
    publicstring Name { get; set; }
    publicstring PhoneNumber { get; set; }
    publicstring Role { get; set; }
}

var records = from x in xml.Descendants("record")
selectnew
{
     AwardDate = (string)x.Element("awardDate"),
      UserList = x.Descendants("user").Select(user => new User
      {
          AccessGrantedDate = string.IsNullOrEmpty((string)user.Element("accessGrantedDate")) ?
                                        (DateTime?)null : DateTime.Parse((string)user.Element("accessGrantedDate")),
           EMailAddress = (string)user.Element("emailAddress"),
           Name = (string)user.Element("name"),
           PhoneNumber = (string)user.Element("phoneNumber"),
           Role = (string)user.Element("role")
})
};

forum

How to extract records of XML using c# linq?

Anonymous User

1 Answers

Liked By